<html>
<header>
  <title>RegistNet-schema</title>
  <style>
  .normalFont {
    font-family: Verdana; font-size: 10pt;
  }
  </style>
</header>

<body class="normalFont">
  <table border="1" cellspacing="0" cellpadding="0">
    <tr bgcolor="#CCCCCC">
      <th class="normalFont">Table Name</th>
      <th class="normalFont">OM Class</th>
      <th class="normalFont">Description</th>
    </tr>
      <tr>
      <td class="normalFont"><a href="#student_view">student_view</a></td>
      <td class="normalFont">StudentView</td>
      <td class="normalFont"> Student View for Course Demand-Based Approach Timetabling</td>
    </tr>
      <tr>
      <td class="normalFont"><a href="#classroom_view">classroom_view</a></td>
      <td class="normalFont">ClassroomView</td>
      <td class="normalFont"> Classroom View for Course Demand-Based Approach Timetabling</td>
    </tr>
      <tr>
      <td class="normalFont"><a href="#course_view">course_view</a></td>
      <td class="normalFont">CourseView</td>
      <td class="normalFont"> Course View for Course Demand-Based Approach Timetabling</td>
    </tr>
      <tr>
      <td class="normalFont"><a href="#valid_subjects_view">valid_subjects_view</a></td>
      <td class="normalFont">ValidSubjectsView</td>
      <td class="normalFont"> Valid Subjects View for Course Demand-Based Approach Timetabling</td>
    </tr>
      <tr>
      <td class="normalFont"><a href="#section">section</a></td>
      <td class="normalFont">Section</td>
      <td class="normalFont"> Section</td>
    </tr>
      <tr>
      <td class="normalFont"><a href="#section_lecture">section_lecture</a></td>
      <td class="normalFont">SectionLecture</td>
      <td class="normalFont"> Section Lecture</td>
    </tr>
      <tr>
      <td class="normalFont"><a href="#section_laboratory">section_laboratory</a></td>
      <td class="normalFont">SectionLaboratory</td>
      <td class="normalFont"> Section Laboratory</td>
    </tr>
      <tr>
      <td class="normalFont"><a href="#slot">slot</a></td>
      <td class="normalFont">Slot</td>
      <td class="normalFont"> Slots of Students</td>
    </tr>
      <tr>
      <td class="normalFont"><a href="#section_view">section_view</a></td>
      <td class="normalFont">SectionView</td>
      <td class="normalFont"> Section View</td>
    </tr>
    </table>

      <a name="student_view"/>
<h2>student_view</h2>
Student View for Course Demand-Based Approach Timetabling
<p/>
<table border="1" cellspacing="0">
  <tr>
    <th class="normalFont" bgcolor="#CCCCCC">Name</th>
    <th class="normalFont" bgcolor="#CCCCCC">Type</th>
    <th class="normalFont" bgcolor="#CCCCCC">Size</th>
    <th class="normalFont" bgcolor="#CCCCCC">Default</th>
    <th class="normalFont" bgcolor="#CCCCCC">JavaName</th>
    <th class="normalFont" bgcolor="#CCCCCC">PK</th>
    <th class="normalFont" bgcolor="#CCCCCC">FK</th>
    <th class="normalFont" bgcolor="#CCCCCC">not null</th>
    <th class="normalFont" bgcolor="#CCCCCC">Description</th>
  </tr>
  <tr>
    <td class="normalFont" id="student_viewstudentId">studentId</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">StudentId</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"> Student Id</td>
  </tr>
  <tr>
    <td class="normalFont" id="student_viewstudentNumber">studentNumber</td>
    <td class="normalFont">CHAR</td>
    <td class="normalFont"> (10) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">StudentNumber</td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Student Number</td>
  </tr>
  <tr>
    <td class="normalFont" id="student_viewfirstName">firstName</td>
    <td class="normalFont">VARCHAR</td>
    <td class="normalFont"> (50) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">FirstName</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Student's First Name</td>
  </tr>
  <tr>
    <td class="normalFont" id="student_viewmiddleName">middleName</td>
    <td class="normalFont">VARCHAR</td>
    <td class="normalFont"> (50) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">MiddleName</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Student's Middle Name</td>
  </tr>
  <tr>
    <td class="normalFont" id="student_viewlastName">lastName</td>
    <td class="normalFont">VARCHAR</td>
    <td class="normalFont"> (50) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">LastName</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Student's Last Name</td>
  </tr>
  <tr>
    <td class="normalFont" id="student_viewdegreeCode">degreeCode</td>
    <td class="normalFont">VARCHAR</td>
    <td class="normalFont"> (10) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">DegreeCode</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Student's Degree Code</td>
  </tr>
</table>
<script>
</script>

      <a name="classroom_view"/>
<h2>classroom_view</h2>
Classroom View for Course Demand-Based Approach Timetabling
<p/>
<table border="1" cellspacing="0">
  <tr>
    <th class="normalFont" bgcolor="#CCCCCC">Name</th>
    <th class="normalFont" bgcolor="#CCCCCC">Type</th>
    <th class="normalFont" bgcolor="#CCCCCC">Size</th>
    <th class="normalFont" bgcolor="#CCCCCC">Default</th>
    <th class="normalFont" bgcolor="#CCCCCC">JavaName</th>
    <th class="normalFont" bgcolor="#CCCCCC">PK</th>
    <th class="normalFont" bgcolor="#CCCCCC">FK</th>
    <th class="normalFont" bgcolor="#CCCCCC">not null</th>
    <th class="normalFont" bgcolor="#CCCCCC">Description</th>
  </tr>
  <tr>
    <td class="normalFont" id="classroom_viewclassroomId">classroomId</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">ClassroomId</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"> Classroom Id</td>
  </tr>
  <tr>
    <td class="normalFont" id="classroom_viewclassroomCode">classroomCode</td>
    <td class="normalFont">VARCHAR</td>
    <td class="normalFont"> (20) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">ClassroomCode</td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Classroom Code</td>
  </tr>
  <tr>
    <td class="normalFont" id="classroom_viewcapacity">capacity</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">Capacity</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Classroom Capacity: The maximum number of students that the room can accomodate. This is determined by the Registrar</td>
  </tr>
  <tr>
    <td class="normalFont" id="classroom_viewroomCategory">roomCategory</td>
    <td class="normalFont">VARCHAR</td>
    <td class="normalFont"> (45) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">RoomCategory</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"> Room Category: This determines the rooms that can be assigned to a subject. The room categories are based on what department and/or subject usually use the room.</td>
  </tr>
</table>
<script>
</script>

      <a name="course_view"/>
<h2>course_view</h2>
Course View for Course Demand-Based Approach Timetabling
<p/>
<table border="1" cellspacing="0">
  <tr>
    <th class="normalFont" bgcolor="#CCCCCC">Name</th>
    <th class="normalFont" bgcolor="#CCCCCC">Type</th>
    <th class="normalFont" bgcolor="#CCCCCC">Size</th>
    <th class="normalFont" bgcolor="#CCCCCC">Default</th>
    <th class="normalFont" bgcolor="#CCCCCC">JavaName</th>
    <th class="normalFont" bgcolor="#CCCCCC">PK</th>
    <th class="normalFont" bgcolor="#CCCCCC">FK</th>
    <th class="normalFont" bgcolor="#CCCCCC">not null</th>
    <th class="normalFont" bgcolor="#CCCCCC">Description</th>
  </tr>
  <tr>
    <td class="normalFont" id="course_viewcourseId">courseId</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">CourseId</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"> Course Id</td>
  </tr>
  <tr>
    <td class="normalFont" id="course_viewcourseCode">courseCode</td>
    <td class="normalFont">VARCHAR</td>
    <td class="normalFont"> (20) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">CourseCode</td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Course Code</td>
  </tr>
  <tr>
    <td class="normalFont" id="course_viewcourseName">courseName</td>
    <td class="normalFont">VARCHAR</td>
    <td class="normalFont"> (80) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">CourseName</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"> Course Name</td>
  </tr>
  <tr>
    <td class="normalFont" id="course_viewcredit">credit</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> (1) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">Credit</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Credit of the course</td>
  </tr>
  <tr>
    <td class="normalFont" id="course_viewlectureHoursPerWeek">lectureHoursPerWeek</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> (1) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">LectureHoursPerWeek</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Lecture Hours Per Week: This is determine by the Registrar or the faculty</td>
  </tr>
  <tr>
    <td class="normalFont" id="course_viewlectureSessionsPerWeek">lectureSessionsPerWeek</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> (1) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">LectureSessionsPerWeek</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Lecture Sessions Per Week: This is determine by the Registrar or the faculty</td>
  </tr>
  <tr>
    <td class="normalFont" id="course_viewminimumNumberOfLectureStudents">minimumNumberOfLectureStudents</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">MinimumNumberOfLectureStudents</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Minimum Number of Lecture Students: This is determine by the Registrar or the faculty</td>
  </tr>
  <tr>
    <td class="normalFont" id="course_viewmaximumNumberOfLectureStudents">maximumNumberOfLectureStudents</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">MaximumNumberOfLectureStudents</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Maximum Number of Lecture Students: This is determine by the Registrar or the faculty</td>
  </tr>
  <tr>
    <td class="normalFont" id="course_viewlectureRoomCategory">lectureRoomCategory</td>
    <td class="normalFont">VARCHAR</td>
    <td class="normalFont"> (45) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">LectureRoomCategory</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"> Lecture Classroom Category: Specifies the kind of lecture room needed by the course</td>
  </tr>
  <tr>
    <td class="normalFont" id="course_viewhasLaboratory">hasLaboratory</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> (1) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">HasLaboratory</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> TRUE if course has laboratory, FALSE otherwise</td>
  </tr>
  <tr>
    <td class="normalFont" id="course_viewlaboratoryHoursPerWeek">laboratoryHoursPerWeek</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> (1) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">LaboratoryHoursPerWeek</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Laboratory Hours Per Week: This is determine by the Registrar or the faculty</td>
  </tr>
  <tr>
    <td class="normalFont" id="course_viewlaboratorySessionsPerWeek">laboratorySessionsPerWeek</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> (1) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">LaboratorySessionsPerWeek</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Laboratory Sessions Per Week: This is determine by the Registrar or the faculty</td>
  </tr>
  <tr>
    <td class="normalFont" id="course_viewminimumNumberOfLaboratoryStudents">minimumNumberOfLaboratoryStudents</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">MinimumNumberOfLaboratoryStudents</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Minimum Number of Laboratory Students: This is determine by the Registrar or the faculty</td>
  </tr>
  <tr>
    <td class="normalFont" id="course_viewmaximumNumberOfLaboratoryStudents">maximumNumberOfLaboratoryStudents</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">MaximumNumberOfLaboratoryStudents</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Maximum Number of Laboratory Students: This is determine by the Registrar or the faculty</td>
  </tr>
  <tr>
    <td class="normalFont" id="course_viewlaboratoryRoomCategory">laboratoryRoomCategory</td>
    <td class="normalFont">VARCHAR</td>
    <td class="normalFont"> (45) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">LaboratoryRoomCategory</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"> Laboratory Classroom Category: Specifies the kind of lecture room needed by the course</td>
  </tr>
  <tr>
    <td class="normalFont" id="course_viewsubjectType">subjectType</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">SubjectType</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Type of subject e.g. NSTP = 4, PE = 3, GE = 0, Major = 1</td>
  </tr>
  <tr>
    <td class="normalFont" id="course_viewmaxNumberOfLectureSections">maxNumberOfLectureSections</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont"> -1</td>
    <td class="normalFont">MaxNumberOfLectureSections</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> The maximum number of lecture sections to be created. -1 if the predicted number of sections is to be used</td>
  </tr>
</table>
<script>
</script>

      <a name="valid_subjects_view"/>
<h2>valid_subjects_view</h2>
Valid Subjects View for Course Demand-Based Approach Timetabling
<p/>
<table border="1" cellspacing="0">
  <tr>
    <th class="normalFont" bgcolor="#CCCCCC">Name</th>
    <th class="normalFont" bgcolor="#CCCCCC">Type</th>
    <th class="normalFont" bgcolor="#CCCCCC">Size</th>
    <th class="normalFont" bgcolor="#CCCCCC">Default</th>
    <th class="normalFont" bgcolor="#CCCCCC">JavaName</th>
    <th class="normalFont" bgcolor="#CCCCCC">PK</th>
    <th class="normalFont" bgcolor="#CCCCCC">FK</th>
    <th class="normalFont" bgcolor="#CCCCCC">not null</th>
    <th class="normalFont" bgcolor="#CCCCCC">Description</th>
  </tr>
  <tr>
    <td class="normalFont" id="valid_subjects_viewstudentNumber">studentNumber</td>
    <td class="normalFont">CHAR</td>
    <td class="normalFont"> (10) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">StudentNumber</td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Student Number</td>
  </tr>
  <tr>
    <td class="normalFont" id="valid_subjects_viewcourseCode">courseCode</td>
    <td class="normalFont">VARCHAR</td>
    <td class="normalFont"> (20) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">CourseCode</td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Course Code</td>
  </tr>
</table>
<script>
</script>

      <a name="section"/>
<h2>section</h2>
Section
<p/>
<table border="1" cellspacing="0">
  <tr>
    <th class="normalFont" bgcolor="#CCCCCC">Name</th>
    <th class="normalFont" bgcolor="#CCCCCC">Type</th>
    <th class="normalFont" bgcolor="#CCCCCC">Size</th>
    <th class="normalFont" bgcolor="#CCCCCC">Default</th>
    <th class="normalFont" bgcolor="#CCCCCC">JavaName</th>
    <th class="normalFont" bgcolor="#CCCCCC">PK</th>
    <th class="normalFont" bgcolor="#CCCCCC">FK</th>
    <th class="normalFont" bgcolor="#CCCCCC">not null</th>
    <th class="normalFont" bgcolor="#CCCCCC">Description</th>
  </tr>
  <tr>
    <td class="normalFont" id="sectionsectionId">sectionId</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">SectionId</td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Section Id</td>
  </tr>
  <tr>
    <td class="normalFont" id="sectionsectionName">sectionName</td>
    <td class="normalFont">VARCHAR</td>
    <td class="normalFont"> (20) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">SectionName</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Section Name</td>
  </tr>
  <tr>
    <td class="normalFont" id="sectionnumberOfStudents">numberOfStudents</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> (4) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">NumberOfStudents</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Number of Students</td>
  </tr>
  <tr>
    <td class="normalFont" id="sectioncourseId">courseId</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">CourseId</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Course Id</td>
  </tr>
</table>
<script>
</script>

      <a name="section_lecture"/>
<h2>section_lecture</h2>
Section Lecture
<p/>
<table border="1" cellspacing="0">
  <tr>
    <th class="normalFont" bgcolor="#CCCCCC">Name</th>
    <th class="normalFont" bgcolor="#CCCCCC">Type</th>
    <th class="normalFont" bgcolor="#CCCCCC">Size</th>
    <th class="normalFont" bgcolor="#CCCCCC">Default</th>
    <th class="normalFont" bgcolor="#CCCCCC">JavaName</th>
    <th class="normalFont" bgcolor="#CCCCCC">PK</th>
    <th class="normalFont" bgcolor="#CCCCCC">FK</th>
    <th class="normalFont" bgcolor="#CCCCCC">not null</th>
    <th class="normalFont" bgcolor="#CCCCCC">Description</th>
  </tr>
  <tr>
    <td class="normalFont" id="section_lecturesectionLectureId">sectionLectureId</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">SectionLectureId</td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Section Lecture Id</td>
  </tr>
  <tr>
    <td class="normalFont" id="section_lecturesectionId">sectionId</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">SectionId</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Section Id</td>
  </tr>
  <tr>
    <td class="normalFont" id="section_lecturedays">days</td>
    <td class="normalFont">VARCHAR</td>
    <td class="normalFont"> (10) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">Days</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Days</td>
  </tr>
  <tr>
    <td class="normalFont" id="section_lectureclassroomId">classroomId</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">ClassroomId</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Classroom Id</td>
  </tr>
  <tr>
    <td class="normalFont" id="section_lecturetime">time</td>
    <td class="normalFont">VARCHAR</td>
    <td class="normalFont"> (20) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">Time</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Days</td>
  </tr>
  <tr>
    <td class="normalFont" id="section_lecturetimeBinary">timeBinary</td>
    <td class="normalFont">BIGINT</td>
    <td class="normalFont"> (20) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">TimeBinary</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Time in Binary</td>
  </tr>
</table>
<script>
</script>

      <a name="section_laboratory"/>
<h2>section_laboratory</h2>
Section Laboratory
<p/>
<table border="1" cellspacing="0">
  <tr>
    <th class="normalFont" bgcolor="#CCCCCC">Name</th>
    <th class="normalFont" bgcolor="#CCCCCC">Type</th>
    <th class="normalFont" bgcolor="#CCCCCC">Size</th>
    <th class="normalFont" bgcolor="#CCCCCC">Default</th>
    <th class="normalFont" bgcolor="#CCCCCC">JavaName</th>
    <th class="normalFont" bgcolor="#CCCCCC">PK</th>
    <th class="normalFont" bgcolor="#CCCCCC">FK</th>
    <th class="normalFont" bgcolor="#CCCCCC">not null</th>
    <th class="normalFont" bgcolor="#CCCCCC">Description</th>
  </tr>
  <tr>
    <td class="normalFont" id="section_laboratorysectionLaboratoryId">sectionLaboratoryId</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">SectionLaboratoryId</td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Section Laboratory Id</td>
  </tr>
  <tr>
    <td class="normalFont" id="section_laboratorysectionId">sectionId</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">SectionId</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Section Id</td>
  </tr>
  <tr>
    <td class="normalFont" id="section_laboratorydays">days</td>
    <td class="normalFont">VARCHAR</td>
    <td class="normalFont"> (10) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">Days</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Days</td>
  </tr>
  <tr>
    <td class="normalFont" id="section_laboratoryclassroomId">classroomId</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">ClassroomId</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Classroom Id</td>
  </tr>
  <tr>
    <td class="normalFont" id="section_laboratorytime">time</td>
    <td class="normalFont">VARCHAR</td>
    <td class="normalFont"> (20) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">Time</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Days</td>
  </tr>
  <tr>
    <td class="normalFont" id="section_laboratorytimeBinary">timeBinary</td>
    <td class="normalFont">BIGINT</td>
    <td class="normalFont"> (20) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">TimeBinary</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Time in Binary</td>
  </tr>
</table>
<script>
</script>

      <a name="slot"/>
<h2>slot</h2>
Slots of Students
<p/>
<table border="1" cellspacing="0">
  <tr>
    <th class="normalFont" bgcolor="#CCCCCC">Name</th>
    <th class="normalFont" bgcolor="#CCCCCC">Type</th>
    <th class="normalFont" bgcolor="#CCCCCC">Size</th>
    <th class="normalFont" bgcolor="#CCCCCC">Default</th>
    <th class="normalFont" bgcolor="#CCCCCC">JavaName</th>
    <th class="normalFont" bgcolor="#CCCCCC">PK</th>
    <th class="normalFont" bgcolor="#CCCCCC">FK</th>
    <th class="normalFont" bgcolor="#CCCCCC">not null</th>
    <th class="normalFont" bgcolor="#CCCCCC">Description</th>
  </tr>
  <tr>
    <td class="normalFont" id="slotslotId">slotId</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">SlotId</td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Slot Id</td>
  </tr>
  <tr>
    <td class="normalFont" id="slotstudentNumber">studentNumber</td>
    <td class="normalFont">CHAR</td>
    <td class="normalFont"> (10) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">StudentNumber</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"> Student Number</td>
  </tr>
  <tr>
    <td class="normalFont" id="slotsectionId">sectionId</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">SectionId</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Section Id</td>
  </tr>
  <tr>
    <td class="normalFont" id="slotstatus">status</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> (1) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">Status</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Slot Status: 0 = VACANT, 3 = RESERVED</td>
  </tr>
</table>
<script>
</script>

      <a name="section_view"/>
<h2>section_view</h2>
Section View
<p/>
<table border="1" cellspacing="0">
  <tr>
    <th class="normalFont" bgcolor="#CCCCCC">Name</th>
    <th class="normalFont" bgcolor="#CCCCCC">Type</th>
    <th class="normalFont" bgcolor="#CCCCCC">Size</th>
    <th class="normalFont" bgcolor="#CCCCCC">Default</th>
    <th class="normalFont" bgcolor="#CCCCCC">JavaName</th>
    <th class="normalFont" bgcolor="#CCCCCC">PK</th>
    <th class="normalFont" bgcolor="#CCCCCC">FK</th>
    <th class="normalFont" bgcolor="#CCCCCC">not null</th>
    <th class="normalFont" bgcolor="#CCCCCC">Description</th>
  </tr>
  <tr>
    <td class="normalFont" id="section_viewsectionId">sectionId</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">SectionId</td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Section Id</td>
  </tr>
  <tr>
    <td class="normalFont" id="section_viewsectionName">sectionName</td>
    <td class="normalFont">VARCHAR</td>
    <td class="normalFont"> (20) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">SectionName</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Section Name: Based on Actual section codes</td>
  </tr>
  <tr>
    <td class="normalFont" id="section_viewcourseCode">courseCode</td>
    <td class="normalFont">VARCHAR</td>
    <td class="normalFont"> (20) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">CourseCode</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Course Code</td>
  </tr>
  <tr>
    <td class="normalFont" id="section_viewnumberOfStudents">numberOfStudents</td>
    <td class="normalFont">INTEGER</td>
    <td class="normalFont"> (4) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">NumberOfStudents</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Number of Students: The maximum number of students that can be accomodated</td>
  </tr>
  <tr>
    <td class="normalFont" id="section_viewlectureDays">lectureDays</td>
    <td class="normalFont">VARCHAR</td>
    <td class="normalFont"> (10) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">LectureDays</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Lecture Days</td>
  </tr>
  <tr>
    <td class="normalFont" id="section_viewlectureTime">lectureTime</td>
    <td class="normalFont">VARCHAR</td>
    <td class="normalFont"> (20) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">LectureTime</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Lecture Time</td>
  </tr>
  <tr>
    <td class="normalFont" id="section_viewlectureClassroomCode">lectureClassroomCode</td>
    <td class="normalFont">VARCHAR</td>
    <td class="normalFont"> (20) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">LectureClassroomCode</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center> X </center></td>
    <td class="normalFont"> Lecture Classroom Code</td>
  </tr>
  <tr>
    <td class="normalFont" id="section_viewlectureTimeBinary">lectureTimeBinary</td>
    <td class="normalFont">BIGINT</td>
    <td class="normalFont"> (20) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">LectureTimeBinary</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"> Lecture Time in Binary</td>
  </tr>
  <tr>
    <td class="normalFont" id="section_viewlaboratoryDays">laboratoryDays</td>
    <td class="normalFont">VARCHAR</td>
    <td class="normalFont"> (10) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">LaboratoryDays</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"> Laboratory Days</td>
  </tr>
  <tr>
    <td class="normalFont" id="section_viewlaboratoryTime">laboratoryTime</td>
    <td class="normalFont">VARCHAR</td>
    <td class="normalFont"> (20) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">LaboratoryTime</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"> Laboratory Time</td>
  </tr>
  <tr>
    <td class="normalFont" id="section_viewlaboratoryClassroomCode">laboratoryClassroomCode</td>
    <td class="normalFont">VARCHAR</td>
    <td class="normalFont"> (20) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">LaboratoryClassroomCode</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"> Laboratory Classroom Code</td>
  </tr>
  <tr>
    <td class="normalFont" id="section_viewlaboratoryTimeBinary">laboratoryTimeBinary</td>
    <td class="normalFont">BIGINT</td>
    <td class="normalFont"> (20) </td>
    <td class="normalFont"> &nbsp;</td>
    <td class="normalFont">LaboratoryTimeBinary</td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"><center>  &nbsp; </center></td>
    <td class="normalFont"> Laboratory Time in Binary</td>
  </tr>
</table>
<script>
</script>

  
</body>
</html>
